 1.需求描述
   
   针对销售数据，完成统计：
   1). 按年统计销售额
   2). 销售金额在 10 W 以上的订单
   3). 每年销售额的差值
   4). 年度订单金额前10位（年度、订单号、订单金额、排名）
   5). 季度订单金额前10位（年度、季度、订单id、订单金额、排名）
   6). 求所有交易日中订单金额最高的前10位
   7). 每年度销售额最大的交易日
   8). 年度最畅销的商品(即每年销售金额最大的商品)
   
 2.数据说明
   
   日期表(dimdate) 
   dt           date       日期
   yearmonth    int        年月
   year         smallint    年
   month        tinyint     月
   day          tinyint     日
   week         tinyint    周几
   weeks        tinyint   第几周
   quat         tinyint    季度
   tendays      tinyint     旬
   halfmonth    tinyint    半月
   
   订单表(sale) 
   orderid    string    订单号
   locationid string   交易位置
   dt           date   交易日期
   
   订单销售明细表(saledetail) 
   orderid   string   订单号
   rownum    int       行号
   itemid    string    货品
   num       int       数量
   price     double    单价
   amount    double    金额
 
 3.实现
   
   步骤一：创建表
   将数据存放在ORC文件中
   -- createtable.hql
   drop database sale cascade;
   create database if not exists sale;
   create table sale.dimdate_ori(
dt date,
yearmonth int,
year smallint,
month tinyint,
day tinyint,
week tinyint,
weeks tinyint,
quat tinyint,
tendays tinyint,
halfmonth tinyint
)
row format delimited
fields terminated by ",";
  
  create table sale.sale_ori(
orderid string,
locationid string,
dt date
)
row format delimited
fields terminated by ",";
  
  create table sale.saledetail_ori(
orderid string,
rownum int,
goods string,
num int,
price double,
amount double
)
row format delimited
fields terminated by ",";
   
   create table sale.dimdate(
dt date,
yearmonth int,
year smallint,
month tinyint,
day tinyint,
week tinyint,
weeks tinyint,
quat tinyint,
tendays tinyint,
halfmonth tinyint
) stored as orc;
  
  create table sale.sale(
orderid string,
locationid string,
dt date
) stored as orc;
   
   create table sale.saledetail(
orderid string,
rownum int,
goods string,
num int,
price double,
amount double
)stored as orc;
  
   hive -f createtable.sql
 
   步骤二：导入数据
   -- 加载数据
   use sale;
   load data local inpath "/root/data/tbDate.txt" overwrite into table dimdate_ori;
   load data local inpath "/root/data/tbSale.txt" overwrite into table sale_ori;
   load data local inpath "/root/data/tbSaleDetail*" overwrite into table saledetail_ori;
   
   -- 导入数据
   insert into table dimdate select * from dimdate_ori;
   insert into table sale select * from sale_ori;
   insert into table saledetail select * from saledetail_ori;
   hive -f loaddata.hql